<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>Administrator</Author>
  <LastAuthor>wuxu</LastAuthor>
  <LastPrinted>2019-03-29T15:37:57Z</LastPrinted>
  <Created>2006-09-13T11:21:00Z</Created>
  <LastSaved>2019-03-29T09:10:03Z</LastSaved>
  <Version>15.00</Version>
 </DocumentProperties>
 <CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <KSOProductBuildVer dt:dt="string">2052-10.1.0.7671</KSOProductBuildVer>
 </CustomDocumentProperties>
 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  <AllowPNG/>
 </OfficeDocumentSettings>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>9225</WindowHeight>
  <WindowWidth>20490</WindowWidth>
  <WindowTopX>0</WindowTopX>
  <WindowTopY>0</WindowTopY>
  <TabRatio>594</TabRatio>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Center"/>
   <Borders/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="m30738118528">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </Style>
  <Style ss:ID="s62">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
  </Style>
  <Style ss:ID="s64">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </Style>
  <Style ss:ID="s72">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
  </Style>
  <Style ss:ID="s75">
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s76">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s77">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Interior ss:Color="#FFFF00" ss:Pattern="Solid"/>
  </Style>
 </Styles>
 <Worksheet ss:Name="明细">
  <Table ss:ExpandedColumnCount="${ColourNum + 5}" ss:ExpandedRowCount="${ProductSizeList?size + StyleNoList?size * 3}" x:FullColumns="1"
   x:FullRows="1" ss:DefaultColumnWidth="53.25" ss:DefaultRowHeight="13.5">
   <Column ss:StyleID="s62" ss:AutoFitWidth="0" ss:Width="105"/>
   <Column ss:StyleID="s62" ss:AutoFitWidth="0" ss:Width="63" ss:Span="${ColourNum + 3}"/>
   <#if StyleNoList?exists && StyleNoList??>
   <#list StyleNoList as styleno>
   <#assign firstrow = 0 />
   <#assign sumrow = 0 />
   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s64"><Data ss:Type="String">明细</Data></Cell>
    <Cell ss:StyleID="s64"/>
    <Cell ss:MergeAcross="${ColourNum - 1}" ss:StyleID="m30738118528"><Data ss:Type="String">纸卡</Data></Cell>
    <Cell ss:StyleID="s64"><Data ss:Type="String">唛头</Data></Cell>
    <Cell ss:StyleID="s64"><Data ss:Type="String">衣架贴</Data></Cell>
    <Cell ss:StyleID="s64"><Data ss:Type="String">圆卡</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s72"/>
    <Cell ss:StyleID="s64"><Data ss:Type="String">码数</Data></Cell>
    <#if ProductColourList?exists && ProductColourList??>
    <#list ProductColourList as item>
    <Cell ss:StyleID="s64"><Data ss:Type="String">${item["colourname"]}</Data></Cell>
    </#list>
    </#if>
    <Cell ss:StyleID="s64"/>
    <Cell ss:StyleID="s64"/>
    <Cell ss:StyleID="s64"/>
   </Row>
   <#if ProductSizeList?exists && ProductSizeList??>
   <#list ProductSizeList as size>
   <#if styleno == size["styleno"]>
   <#assign firstrow = firstrow + 1 />
   <#assign sumrow = sumrow + 1 />
   <Row ss:AutoFitHeight="0" ss:StyleID="s75">
    <#if firstrow == 1>
    <Cell ss:StyleID="s64"><Data ss:Type="String">${size["styleno"]}</Data></Cell>
    <#elseif firstrow == 2>
    <Cell ss:StyleID="s64"><Data ss:Type="String">${size["productname"]}</Data></Cell>
    <#else>
    <Cell ss:StyleID="s64"/>
    </#if>
    <Cell ss:StyleID="s76"><Data ss:Type="String">${size["sizename"]}</Data></Cell>
    <#assign rowquantity = 0 />
    <#-- 写入每色对应尺码的数量 -->
    <#if ProductColourList?exists && ProductColourList??>
    <#list ProductColourList as colour>
    <#assign flag = false />
    <#if ProductQuantityList?exists && ProductQuantityList??>
    <#list ProductQuantityList as quantity>
    <#if size["styleno"] == quantity["styleno"]>
    <#if colour["colourname"] == quantity["colourcnname"] && size["sizename"] == quantity["sizename"]>
    <Cell ss:StyleID="s76"><Data ss:Type="Number">${quantity["quantity"]}</Data></Cell>
    <#assign rowquantity = rowquantity + quantity["quantity"] />
    <#assign flag = true />
    <#break/>
    </#if>
    </#if>
    </#list>
    <#if flag == false>
    <Cell ss:StyleID="s76"/>
    </#if>
    </#if>
    </#list>
    </#if>
    <Cell ss:StyleID="s64" ss:Formula="=SUM(RC[-${ProductColourList?size}]:RC[-1])"><Data ss:Type="Number">0</Data></Cell>
    <#assign hangerflag = false />
    <#if HangerStickerQuantity?exists && HangerStickerQuantity??>
    <#list HangerStickerQuantity as hangerSticker>
    <#if size["styleno"] == hangerSticker["styleno"] && size["sizename"] == hangerSticker["sizename"]>
    <Cell ss:StyleID="s64"><Data ss:Type="Number">hangerSticker["quantity"]}</Data></Cell>
    <#assign hangerflag = true />
    <#break/>
    </#if>
    </#list>
    </#if>
    <#if hangerflag == false>
    <Cell ss:StyleID="s64" ss:Formula="=RC[-1]-RC[1]"><Data ss:Type="Number">0</Data></Cell>
    </#if>
    <#assign roundflag = false />
    <#if RoundCardQuantity?exists && RoundCardQuantity??>
    <#list RoundCardQuantity as roundcard>
    <#if size["styleno"] == roundcard["styleno"] && size["sizename"] == roundcard["sizename"]>
    <Cell ss:StyleID="s64"><Data ss:Type="Number">${roundcard["quantity"]}</Data></Cell>
    <#assign roundflag = true />
    <#break/>
    </#if>
    </#list>
    </#if>
    <#if roundflag == false>
    <Cell ss:StyleID="s64"><Data ss:Type="Number">0</Data></Cell>
    </#if>
   </Row>
   </#if>
   </#list>
   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s77"><Data ss:Type="String">合计</Data></Cell>
    <Cell ss:StyleID="s77"/>
    <#list 1..(ProductColourList?size + 3) as t>
    <Cell ss:StyleID="s77" ss:Formula="=SUM(R[-${sumrow}]C:R[-1]C)"><Data ss:Type="Number">0</Data></Cell>
    </#list>
   </Row>
   </#if>
   </#list>
   </#if>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <PageSetup>
    <Header x:Margin="0.51180555555555596"/>
    <Footer x:Margin="0.51180555555555596"/>
   </PageSetup>
   <Unsynced/>
   <Print>
    <ValidPrinterInfo/>
    <PaperSizeIndex>9</PaperSizeIndex>
    <HorizontalResolution>600</HorizontalResolution>
    <VerticalResolution>600</VerticalResolution>
   </Print>
   <PageBreakZoom>100</PageBreakZoom>
   <Selected/>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>
